package database.DatabaseHelpers;



public class UserConstants {

	public static final String TABLE_USER = "user";
	public static final String COLUMN_ID = "_id";
	public static final String COLUMN_USERNAME = "username";
	public static final String COLUMN_PW = "password";
	public static final String COLUMN_PRIMARY_MAIL = "mail";
	public static final String COLUMN_AGE = "age";
	public static final String COLUMN_SEX = "sex";
	public static final String COLUMN_HOME = "home";
	

	// Database creation sql statement
	public static final String DATABASE_CREATE = "create table "
			+ TABLE_USER + "( " + COLUMN_ID
			+ " integer primary key autoincrement, " + COLUMN_USERNAME
			+ " text not null, "+ COLUMN_PW + " text not null, "
			+ COLUMN_PRIMARY_MAIL + " text not null, "
			+ COLUMN_AGE + " text, "
			+ COLUMN_SEX + " text, "
			+ COLUMN_HOME + " text);";

	

}